Write an SQL query to fetch the first 50% records from a table.

SQL - Interview Questions

Write an SQL query to fetch the first 50% records from a table.

The required query is:

SELECT * FROM WORKER
WHERE WORKER_ID <= (SELECT count(WORKER_ID)/2 from Worker);

More Technologies Interview Questions

Machine Learning

Artificial Intelligence

Ethical Hacking

HyperAutomation

Microsoft Azure

Cloud Computing

Quantum Computing

Cognitive Computing

Neural Networks

Virtual Reality

Augmented Reality

Full Stack Developer

Advertisement